-
- Rate Projections Functions Walkthrough
- Accruals and Cash
- Repeating Formulae
- Range Names and References
- Optional Parameters
- Using PmtsPerYear
- Modelling Seasonality
- Calculating Interest
- Using Business Functions in VBA (Visual Basic for Applications)
- Array Functions
- Volatility
- Annual Equivalent Rates
- Array Function
- Auto Multi Functions
- Variable Plurality
- GoalSeek
- This option simply does a copy of the values and formats only, from a source range to a destination range.
- This is useful because "Range-Valuing" in Excel involves the tedious process of Copying and the using Paste Special.
Range Value | |
Transforms a range into just numbers | |